Using the Balance Sheet Budget Allocations utility

The Balance Sheet Budget Allocations utility allows you to allocate top-of-the-house planned balances and related interest to the lower levels of the organizational structure within a budget.

With this utility, you can do the following:

  • Review allocations and troubleshoot balance discrepancies by viewing the report included in the utility.

  • Run the utility to process allocations for a budget based on allocations defined in the Balance Sheet Allocation driver.

IMPORTANT: Before using this utility, make sure to configure or edit the Balance Sheet Allocation driver. You will not be able to process this utility until the driver is configured.

Reviewing or troubleshooting allocation balances

The Report sheet shows you the difference between pre-allocation and the post-allocation balances. A difference between these balances means that an error occurred in the allocation process. You will know that the system processed the allocations correctly when the difference equals zero.

To troubleshoot allocation balances:

  1. Open a budget, scenario, or forecast.

  2. From the Plan Utilities tab, click Balance Sheet Budget Allocations from the list of planning utilities.

    NOTE: The utility opens in the Desktop Client.

  3. If you have not yet processed balance sheet allocations, you can do so in the Main ribbon tab, by clicking File Processing, and selecting Process File Multipass.

    Click image to view full size

  4. After all allocations have been processed, go to the Report sheet, and on the Main ribbon tab, click Refresh .

  5. In the Refresh Variables dialog, from the drop-down list, select Report.

  6. When you are done, close the utility.

For further information, you can also view the source balances, allocation percentage, and the breakdown of each allocation and its corresponding departments by viewing the Allocation sheet.

Processing balance sheet budget allocations for a budget

To process balance sheet budget allocations for a budget:

  1. Open a budget, scenario, or forecast.
  2. Click the Plan Utilities tab.
  3. Do one of the following:

    • To process only this utility, in the Process Plan Utilities column, locate Balance Sheet Budget Allocations in the list, and click Process.

    • To process all planning utilities, click Process All.

TIP: Axiom will notify you when your scheduled job is completed. For more information, see Viewing notifications in the Web Client.